IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'UserLogin')
	BEGIN
		DROP  Procedure  UserLogin
	END

GO

CREATE Procedure UserLogin
(
	@UserName varchar(20)
	, @Password varchar(16)
)
AS

SELECT UserID 
	, UserName
	, Password
	, FullName
	, UserType
FROM Users
WHERE UserName = @UserName 
	AND Password = @Password

